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