UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r9qWvKOOtYgQ6dPEeh1ww4MnWmmggjWEGE3J7K3Dbco='
WHERE
key_id = '05245f2b47c31bce1dcf369ec1f137a9ee2f4664a186ce975432babf3ff3da5a'
AND (
token = 'r9qWvKOOtYgQ6dPEeh1ww4MnWmmggjWEGE3J7K3Dbco='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)