UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2qj+vwkr43qzSJFscb0gwmr2dEVlzunrq23lockX3KY='
WHERE
key_id = 'd1eacc3079d085984171b41a4429c58f69e0c23d6589c47c4db742c95da51e42'
AND (
token = '2qj+vwkr43qzSJFscb0gwmr2dEVlzunrq23lockX3KY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)