UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZHz+MSRisFG4ciSGOLxs5nRJ6NpDUsJ1K0LuLAAfir8='
WHERE
key_id = '12da5a64e2db546ef0258d6c86728c2b6b3b298e67c56ed26a09b343db3ff445'
AND (
token = 'ZHz+MSRisFG4ciSGOLxs5nRJ6NpDUsJ1K0LuLAAfir8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)