UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YPMc8w8KlNgyeUChAYjCok1mKzZZiXJPZPwk71Zmdbk='
WHERE
key_id = 'a04a8fc8f183091cb0eed831fe9ef2ee38c188b6ff19b03b571497deaccb5310'
AND (
token = 'YPMc8w8KlNgyeUChAYjCok1mKzZZiXJPZPwk71Zmdbk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)