UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ef04Ps3gqEAMDYvUntjsuyuP/g4kxcyrQQaOvP/FPDo='
WHERE
key_id = 'fb8711ce123a0a4d5b8ff4cf490ff853f36f1933b5aff6d01f2fe41c388f09fb'
AND (
token = 'ef04Ps3gqEAMDYvUntjsuyuP/g4kxcyrQQaOvP/FPDo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)