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