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