UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'b5CQloZdNhSi32GoZw7eNCNlZYcNHxfJImZZkJwye4A='
WHERE
key_id = '88ae9b95d192e5e9964daa28a6aeee3a1976ce5671e44ac4aad3920a1a623937'
AND (
token = 'b5CQloZdNhSi32GoZw7eNCNlZYcNHxfJImZZkJwye4A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)