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