UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'avmNxfdqNxaBB+gD1YKXrTQMU7GwkzgFe5U/z1YT6cA='
WHERE
key_id = '82a5d1e52e2dfb164c481d3e21bbaedea116b38670f30865f9d286d5ebf1249a'
AND (
token = 'avmNxfdqNxaBB+gD1YKXrTQMU7GwkzgFe5U/z1YT6cA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)