UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ca2nSkPH/vHM0DXr2Kp0Z86muN4fh59ccmK/e51t+IQ='
WHERE
key_id = 'bd9b49b8e2eb4eba08d2fce0b54c6d811deea1d7a4abfd447b43f9b9e167c95d'
AND (
token = 'ca2nSkPH/vHM0DXr2Kp0Z86muN4fh59ccmK/e51t+IQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)