UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZzamfBfpTtb41cfRHkI4tyJViAxScpcAHHHiZUkBTgM='
WHERE
key_id = '80bf7ec58f9273fbf37999499a1891e8b0930983af90d23b4c483cb0b465f6ad'
AND (
token = 'ZzamfBfpTtb41cfRHkI4tyJViAxScpcAHHHiZUkBTgM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)