UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yaHThHsA7ZZQtinovsP+6g8Y1G8mlmfNyCoWqN+diHw='
WHERE
key_id = '96a8d6221328edd67b3029709cf5e450887fb43e049be59157fcc06240e34e38'
AND (
token = 'yaHThHsA7ZZQtinovsP+6g8Y1G8mlmfNyCoWqN+diHw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)