UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zGFvXixbZ74DcJ4KZ93MF5zztlFFb+/1yIlXj0yY53k='
WHERE
key_id = '5837e875701be13f9acf1da4b5adbdd5c2f9823d0c0ce72bdd03c64c054e5ac6'
AND (
token = 'zGFvXixbZ74DcJ4KZ93MF5zztlFFb+/1yIlXj0yY53k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)