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