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