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