UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nl+81zp1Shn8fkW76hAKp2NqpKD5Ru93J3TdVmjnB08='
WHERE
key_id = 'e7f46d312dce02e962187c9764682a298ef1b79b80c2f47a9c251670e81daa6d'
AND (
token = 'nl+81zp1Shn8fkW76hAKp2NqpKD5Ru93J3TdVmjnB08='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)