UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E7KFjU83MIcefQvMMEd2ekW9cJwMt3VKA2OUA7U6iVc='
WHERE
key_id = '116d2e50a433eb0edbd2ec73933bb3dc80bad45cad1d3b80a60b61062173c639'
AND (
token = 'E7KFjU83MIcefQvMMEd2ekW9cJwMt3VKA2OUA7U6iVc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)