UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8YiLu04dJoLHjcYQtSeU8Q+IOhiBH2jQRc2HHhaxcZE='
WHERE
key_id = 'bf416459299c1c23761cc8cb0d53fb7c9975c843ce958a4e4275b8587151abdb'
AND (
token = '8YiLu04dJoLHjcYQtSeU8Q+IOhiBH2jQRc2HHhaxcZE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)