UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZK2d3+4dJN0fzj3IFVEcQMmJ8oWJlxgzbTAC1qMfOjQ='
WHERE
key_id = '18fc8f57cdb9bd0ed90fafa15d03e0cade9a4fe4ca20781f44e7e3fca95cf047'
AND (
token = 'ZK2d3+4dJN0fzj3IFVEcQMmJ8oWJlxgzbTAC1qMfOjQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)