UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DcA19qM/pX5NlZ9XVZc95GjN7s5Gki+CE4tJAohGoxA='
WHERE
key_id = '12a01e747d037cdfd15e239bc37150672459fdbb222c003728fe1962b15814f0'
AND (
token = 'DcA19qM/pX5NlZ9XVZc95GjN7s5Gki+CE4tJAohGoxA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)