UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eEOypRTHwHQs8BnuTjU6isb/xE6uizD4OvrNFQjwEg8='
WHERE
key_id = '7faf76d27df1bcd2c94a507dcce407ff762b58186b1162af08e9b4f7b8078739'
AND (
token = 'eEOypRTHwHQs8BnuTjU6isb/xE6uizD4OvrNFQjwEg8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)