UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xJCTblxfqWFpUfR90GWNOhREvFlbfM1z6yYpd31dt88='
WHERE
key_id = '1f27519bdd92e9b9a45eba0a78900af78b4e0f912606e7be018e089ac4e9c50d'
AND (
token = 'xJCTblxfqWFpUfR90GWNOhREvFlbfM1z6yYpd31dt88='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)