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