UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '80BWtYmmbTrYn9S/GsPBaZz8HtsftZR2zjRqwBk9JDE='
WHERE
key_id = 'de7a7ff5b8c12e46c1573ec0cb780b82dd9a6e63dacdc417006972ccd77998dc'
AND (
token = '80BWtYmmbTrYn9S/GsPBaZz8HtsftZR2zjRqwBk9JDE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)