UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W8ri/oSIhB7R48TpIah9QvrjBfCLodGIpWF3RsxJbvA='
WHERE
key_id = 'e42cb9fe7ae20a0d42130615269f0660d4a0928575596925f719676d1b95aa28'
AND (
token = 'W8ri/oSIhB7R48TpIah9QvrjBfCLodGIpWF3RsxJbvA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)