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