UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7C34h1IFxydVR8sHnXkynQ7j3lYkCVdcBy85Mq6om1Y='
WHERE
key_id = '8989b9500faade7fb8f9b8a5b22f545cbb44af842d5c0880c19d9108c8118ac3'
AND (
token = '7C34h1IFxydVR8sHnXkynQ7j3lYkCVdcBy85Mq6om1Y='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)