UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4jTt+ePxXEBxbjGP2F1RZeTU+6lNeLPA/d+1Js8B32c='
WHERE
key_id = 'bd4816bcfa70475849562338d35a8ffce0ae02e33cd78840d5bfe8be1dd76711'
AND (
token = '4jTt+ePxXEBxbjGP2F1RZeTU+6lNeLPA/d+1Js8B32c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)