UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '29bBkVyBtFI7OPtEmTZWXxfkPDluxfKOOW3fxLBuF28='
WHERE
key_id = '820e54657a85fbc6c92e5c548925e246c4f5def1e001dc941ed8bc7ef032063a'
AND (
token = '29bBkVyBtFI7OPtEmTZWXxfkPDluxfKOOW3fxLBuF28='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)