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